How to: AutoFormat a range.
Solution:
Select 'AutoFormat...' from the 'Format' menu and select the desired format from the 'Table Format' list box.
1) Select the range to format.
2) Select the 'Format' menu and select 'AutoFormat...'. (The AutoFormat dialog box appears.)
3) Select the desired format from the 'Table Format' list box.
Selecting the desired format
4) Click 'OK'. (Excel automatically applies the format to the range.)
